create external table jms_dim.dim_tab_channel_mapping_online_base
(
  channel_code string comment '订单来源编码'
  ,channel_name string comment '订单来源名称'
  ,channel_type string comment '订单一级分类'
)comment '散单来源配置表'
STORED AS PARQUET
LOCATION '/dw/hive/jms_dim.db/external/dim_tab_channel_mapping_online_base'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
)
